package com.apes.fn.business.insurance.repository;

import com.apes.fn.business.insurance.modle.PolicyInformation;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

/**
 * @ClassName : policyInformationRepository
 * @Description : 数据库连接层
 * @Author : WSJ
 * @Date: 2020-04-28 17:04
 */
public interface PolicyInformationRepository extends CustomRepository<PolicyInformation,String> {

    @Query(value = "select * from POLICY_INFORMATION where ID LIKE :id || '-XG' || '%' ", nativeQuery = true)
    List<PolicyInformation> findByXG(String id);

}
